select * from Users where UserName like'r%'
order by CreationDate desc

use MvcCms 
DECLARE @RoleName nvarchar(256)
SET @RoleName = 'admin'
DECLARE @RoleId uniqueidentifier
SELECT  @RoleId = NULL
SELECT  @RoleId = RoleId
FROM    dbo.Roles
WHERE   LOWER(@RoleName) = LoweredRoleName 
SELECT u.UserName, Password, email
FROM   dbo.Users u, dbo.UsersInRoles ur
WHERE  u.UserId = ur.UserId AND @RoleId = ur.RoleId 
ORDER BY u.UserName